﻿
CREATE PROCEDURE GetCargoInformation
AS
	SELECT TOP 10
		cargo.Name AS Cargo_Name,
		cargo.[Description] AS Cargo_Description,
		cargo.ShortCode AS Code,
		cargo.Code AS CodeETSNG,
		cargoETSNG.Name AS CargoETSNG_Name,
		cargo.CodeGNG AS CodeGNG,
		cargoGNG.Name AS CargoGNG_Name,
		cargo.Mnemocode
	FROM
		dbo.Cargo AS cargo
		inner join CargoETSNG AS cargoETSNG ON cargo.Code = cargoETSNG.CargoETSNG_ID
		inner join CargoGNG AS cargoGNG ON cargo.CodeGNG = cargoGNG.CargoGNG_ID